SHOW-LOAD-WARNINGS

SHOW-LOAD-WARNINGS

Name

SHOW LOAD WARNINGS

Description

If the import task fails and the error message is ETL_QUALITY_UNSATISFIED, it means that there is an import quality problem. If you want to see these problematic import tasks, you can use the SHOW LOAD WARNINGS statement.

Syntax:

SHOW LOAD WARNINGS
[FROM db_name]
[
    WHERE
    [LABEL[="your_label"]]
    [LOAD_JOB_ID = ["job id"]]
]

1) If db_name is not specified, the current db is used by default. 1) If LABEL = is specified, it matches the specified label exactly. 1) If LOAD_JOB_ID is specified, it matches the specified JOB ID exactly.

Example

1. Display the data with quality problems in the import task of the specified db, and specify the label as "load_demo_20210112"

   SHOW LOAD WARNINGS FROM demo WHERE LABEL = "load_demo_20210112"

Keywords

SHOW, LOAD, WARNINGS

Best Practice